package com.github.edu.repair.manager.domain;

import com.github.admin.edu.orm.repository.CustomRepository;
import com.github.edu.repair.manager.entity.TBxLyxx;
import org.springframework.data.jpa.repository.Query;
import org.springframework.data.repository.query.Param;

import java.util.List;

/**
 * Created by IntelliJ IDEA.
 * user:wangj
 * date:2018/8/20
 * Time: 22:01
 */
public interface LyxxServerDomain extends CustomRepository<TBxLyxx,Integer> {

    @Query("select t from TBxLyxx t where t.sfqy = 1 and t.ssqy=:qyid")
    List<TBxLyxx> getAllBySsqy(@Param("qyid")Integer qyid);

}
